from openpyxl import load_workbook

wb = load_workbook('test2.xlsx')

# 所有工作表的名称
sheets = wb.sheetnames
print(sheets)
